1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11 namespace SoftQuanLyNhaHang.Models
12 {
13 class NhapHangMod
14 {
15 protected int PageSize { get; set; }
16 protected int PageIndex { get; set; }
17
18 protected int IdNhapHang { get; set; }
19 protected string IdNhapHangStr { get; set; }
20
21 protected string IdNhapHang_MaNH { get; set; }
22 protected DateTime NgayTao { get; set; }
23 protected string TrangThai { get; set; }
24 protected double GiamGiaDonHang { get; set; }
25 protected double GiamGiaTatCaCacMuc { get; set; }
26 protected double TongDonHang { get; set; }
27 protected double No_NCC { get; set; }
28 protected double NCC_NoChuCuaHang { get; set; }
29 protected string GhiChu { get; set; }
30 protected int NhaCungCapId { get; set; }
31 protected double ChiPhiThem { get; set; }
32 protected string MoTaChiPhiThem { get; set; }
33 protected double TienThanhToan { get; set; }
34 protected string TenDonHang { get; set; }
35
36 public NhapHangMod(int _IdNhapHang)
37 {
38 IdNhapHang = _IdNhapHang;
39 }
40
41 public NhapHangMod()
42 {
43
44 }
45
46 public NhapHangMod(string _IdNhapHangStr, int _NhaCungCapId, string _TrangThai)
47 {
48 IdNhapHangStr = _IdNhapHangStr;
49 NhaCungCapId = _NhaCungCapId;
50 TrangThai = _TrangThai;
51 }
52
53 public NhapHangMod(int _idNhapHang, double _No_NCC)
54 {
55 IdNhapHang = _idNhapHang;
56 No_NCC = _No_NCC;
57 }
58
59 public NhapHangMod(int _idNhapHang, string _tenDonHang, string _ghiChu)
60 {
61 IdNhapHang = _idNhapHang;
62 TenDonHang = _tenDonHang;
63 GhiChu = _ghiChu;
64 }
65
66 public NhapHangMod(string _trangThai, int _pageSize, int _pageIndex)
67 {
68 TrangThai = _trangThai;
69 PageSize = _pageSize;
70 PageIndex = _pageIndex;
71 }
72
73 public NhapHangMod(string _trangThai, int _pageSize, int _pageIndex, string _IdNhapHang_MaNH, string _TenDonHang, int _NhaCungCapId)
74 {
75 TrangThai = _trangThai;
76 PageSize = _pageSize;
77 PageIndex = _pageIndex;
78 IdNhapHang_MaNH = _IdNhapHang_MaNH;
79 TenDonHang = _TenDonHang;
80 NhaCungCapId = _NhaCungCapId;
81 }
82
83 public NhapHangMod(int _IdNhapHang, DateTime _NgayTao, string _TrangThai, double _GiamGiaDonHang, double _GiamGiaTatCaCacMuc, double _TongDonHang, double _No_NCC, double _NCC_NoChuCuaHang, string _GhiChu, int _NhaCungCapId, double _ChiPhiThem, string _MoTaChiPhiThem, double _TienThanhToan, string _TenDonHang)
84 {
85 IdNhapHang = _IdNhapHang;
86 NgayTao = _NgayTao ;
87 TrangThai = _TrangThai ;
88 GiamGiaDonHang = _GiamGiaDonHang;
89 GiamGiaTatCaCacMuc = _GiamGiaTatCaCacMuc;
90 TongDonHang = _TongDonHang;
91 No_NCC = _No_NCC;
92 NCC_NoChuCuaHang = _NCC_NoChuCuaHang;
93 GhiChu = _GhiChu ;
94 NhaCungCapId = _NhaCungCapId;
95 ChiPhiThem = _ChiPhiThem;
96 MoTaChiPhiThem = _MoTaChiPhiThem;
97 TienThanhToan = _TienThanhToan;
98 TenDonHang = _TenDonHang;
99 }
100
101 //Them moi dvt
102 public int InsertNhapHang()
103 {
104 int i = 0;
105 string[] paras = new string[14] { "@IdNhapHang", "@NgayTao", "@TrangThai", "@GiamGiaDonHang", "@GiamGiaTatCaCacMuc", "@TongDonHang", "@No_NCC", "@NCC_NoChuCuaHang", "@GhiChu", "@NhaCungCapId", "@ChiPhiThem", "@MoTaChiPhiThem", "@TienThanhToan", "@TenDonHang"};
106 object[] values = new object[14] { IdNhapHang, NgayTao, TrangThai, GiamGiaDonHang, GiamGiaTatCaCacMuc, TongDonHang, No_NCC, NCC_NoChuCuaHang, GhiChu, NhaCungCapId, ChiPhiThem, MoTaChiPhiThem, TienThanhToan, TenDonHang };
107 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_NhapHang_Insert", CommandType.StoredProcedure, paras, values));
108 return i;
109 }
110
111 public int InsertNhapHangCopy()
112 {
113 int i = 0;
114 string[] paras = new string[1] { "@IdNhapHang"};
115 object[] values = new object[1] { IdNhapHang};
116 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_NhapHang_Copy", CommandType.StoredProcedure, paras, values));
117 return i;
118 }
119
120 //update mod don vi tinh
121 public int UpdateNhapHang()
122 {
123 int i = 0;
124 string[] paras = new string[14] { "@IdNhapHang", "@NgayTao", "@TrangThai", "@GiamGiaDonHang", "@GiamGiaTatCaCacMuc", "@TongDonHang", "@No_NCC", "@NCC_NoChuCuaHang", "@GhiChu", "@NhaCungCapId", "@ChiPhiThem", "@MoTaChiPhiThem", "@TienThanhToan" , "@TenDonHang"};
125 object[] values = new object[14] { IdNhapHang, NgayTao, TrangThai, GiamGiaDonHang, GiamGiaTatCaCacMuc, TongDonHang, No_NCC, NCC_NoChuCuaHang, GhiChu, NhaCungCapId, ChiPhiThem, MoTaChiPhiThem, TienThanhToan, TenDonHang };
126 i = Models.connection.Excute_Sql("tbl_NhapHang_Update", CommandType.StoredProcedure, paras, values);
127 return i;
128 }
129
130 //update noncc
131 public int UpdateNhapHang_No_NCC()
132 {
133 int i = 0;
134 string[] paras = new string[2] { "@IdNhapHang", "@No_NCC" };
135 object[] values = new object[2] { IdNhapHang, No_NCC};
136 i = Models.connection.Excute_Sql("tbl_NhapHang_Update_No_Ncc", CommandType.StoredProcedure, paras, values);
137 return i;
138 }
139 public int UpdateNhapHang_Ten_GhiChu()
140 {
141 int i = 0;
142 string[] paras = new string[3] { "@IdNhapHang", "@TenDonHang" ,"@GhiChu"};
143 object[] values = new object[3] { IdNhapHang, TenDonHang, GhiChu };
144 i = Models.connection.Excute_Sql("tbl_NhapHang_Update_Ten_GhiChu", CommandType.StoredProcedure, paras, values);
145 return i;
146 }
147
148 //update ten va ghichu
149
150
151 //delete
152 public int DeleteNhapHang()
153 {
154 int i = 0;
155 string[] paras = new string[1] { "@IdNhapHang" };
156 object[] values = new object[1] { IdNhapHang };
157 i = Models.connection.Excute_Sql("tbl_NhapHang_Delete", CommandType.StoredProcedure, paras, values);
158 return i;
159 }
160
161 public DataSet FillDataSet_NhapHang_SearchByTrangThai()
162 {
163 DataSet ds = new DataSet();
164 string[] paras = new string[3] { "@TrangThai", "@PageSize", "@PageIndex" };
165 object[] values = new object[3] { TrangThai, PageSize, PageIndex };
166 ds = Models.connection.FillDataSet("tbl_NhapHang_SearchByTrangThai", CommandType.StoredProcedure, paras, values);
167 return ds;
168 }
169 //search co phan tram co like
170 public DataSet FillDataSet_NhapHang_SearchByTrangThai_Search()
171 {
172 DataSet ds = new DataSet();
173 string[] paras = new string[6] { "@TrangThai", "@PageSize", "@PageIndex", "@IdNhapHang_MaNH", "@TenDonHang", "@NhaCungCapId" };
174 object[] values = new object[6] { TrangThai, PageSize, PageIndex, IdNhapHang_MaNH, TenDonHang, NhaCungCapId };
175 ds = Models.connection.FillDataSet("tbl_NhapHang_SearchByTrangThai", CommandType.StoredProcedure, paras, values);
176 return ds;
177 }
178
179 //lấy tất các sản phẩm trong kho thuộc nhaphangid
180 public DataSet FillDataSet_NhapHang_GetAll_Kho_ByNhapHangId()
181 {
182 DataSet ds = new DataSet();
183 string[] paras = new string[1] { "@IdNhapHang" };
184 object[] values = new object[1] { IdNhapHang };
185 ds = Models.connection.FillDataSet("tbl_NhapHang_GetAll_Kho_ByNhapHangId", CommandType.StoredProcedure, paras, values);
186 return ds;
187 }
188
189 //lấy thông tin trong bảng nhập hàng
190 public DataSet FillDataSet_NhapHang_Get_ByNhapHangId()
191 {
192 DataSet ds = new DataSet();
193 string[] paras = new string[1] { "@IdNhapHang" };
194 object[] values = new object[1] { IdNhapHang };
195 ds = Models.connection.FillDataSet("tbl_NhapHang_Get", CommandType.StoredProcedure, paras, values);
196 return ds;
197 }
198
199
200 //lay thong tin thanh toan ncc
201 public DataSet FillDataSet_NhapHang_Get_ByNCC_IdNhStr()
202 {
203 DataSet ds = new DataSet();
204 string[] paras = new string[3] { "@IdNhapHangStr", "@NhaCungCapId", "@TrangThai"};
205 object[] values = new object[3] { IdNhapHangStr, NhaCungCapId ,TrangThai};
206 ds = Models.connection.FillDataSet("tbl_NhapHang_Get_ByNcc_IdNhStr", CommandType.StoredProcedure, paras, values);
207 return ds;
208 }
209 }
210 }